alter proc [dbo].[SP_GET_APPOINTMENTS_EPLOYEE_BYDATE]      
( @APP_DATE datetime,    
 @APP_STARTTIME DATETIME,  
  @ACC_ID int  
)      
AS      
select  EMP_ID,(EMP_FIRSTNAME +' '+ EMP_LASTNAME) AS FULLNAME,dbo.EMPLOYEES.EMP_ID      
from dbo.EMPLOYEES       
where EMP_ID NOT IN(      
select APPOINTMENTS.EMP_ID from APPOINTMENTS       
where APP_STATUS!='DENY' AND APP_DATE=@APP_DATE  AND APP_STARTTIME=@APP_STARTTIME)
and dbo.EMPLOYEES.ACC_ID=@ACC_ID